//    Copyright (C) 2013  <lugocreation@gmail.com>
//
//    This program is free software: you can redistribute it and/or modify
//    it under the terms of the GNU General Public License as published by
//    the Free Software Foundation, either version 3 of the License, or
//    (at your option) any later version.
//
//    This program is distributed in the hope that it will be useful,
//    but WITHOUT ANY WARRANTY; without even the implied warranty of
//    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
//    GNU General Public License for more details.
//
//    You should have received a copy of the GNU General Public License
//    along with this program.  If not, see <http://www.gnu.org/licenses/>.
package org.jpgolay.me.persistence;

public class PersistenceSQL {

    public PersistenceSQL() {
    }
    public static final String SALES_PIECE_INSERT = "INSERT INTO ventes (id,update_time,prefixe) VALUES (?,?,?)";
    public static final String SALES_PIECE_UPDATE = "UPDATE ventes SET id=?,prefixe=?,date=?,clients_id=?,commerciaux_id=?,contenu=?,net_a_payer=?,echeance=?,date_livraison=?,livre=?,date_relance=?,montant_regle=?,mode_reglement=?,solde_le=?,entreprise_id=?,prepared=?,total_brut_ht=?,commentaire=?,total_taxes=?,montant_tva1=?,montant_tva2=?,montant_tva3=?,montant_tva4=?,montant_tva5=?,no_fact=?,update_user_id=?,update_time=?,total_sous_total=?,tva_port=? WHERE id=? AND update_time=?";
    public static final String SALES_PIECE_DELETE = "DELETE FROM ventes WHERE id=? AND update_time=?";
    public static final String SALES_PIECE_SELECT = "SELECT id,prefixe,date,clients_id,commerciaux_id,contenu,net_a_payer,echeance,date_livraison,livre,date_relance,montant_regle,mode_reglement,solde_le,entreprise_id,prepared,total_brut_ht,commentaire,total_taxes,montant_tva1,montant_tva2,montant_tva3,montant_tva4,montant_tva5,no_fact,update_user_id,update_time,total_sous_total,tva_port FROM ventes WHERE id=?";
    public static final String SALES_PIECE_SELECT_ALL = "SELECT id,prefixe,date,clients_id,commerciaux_id,contenu,net_a_payer,echeance,date_livraison,livre,date_relance,montant_regle,mode_reglement,solde_le,entreprise_id,prepared,total_brut_ht,commentaire,total_taxes,montant_tva1,montant_tva2,montant_tva3,montant_tva4,montant_tva5,no_fact,update_user_id,update_time,total_sous_total,tva_port FROM ventes WHERE entreprise_id=?";
    public static final String SALES_BILL_PIECE_INSERT = "INSERT INTO ventes_factures (id,update_time,prefixe) VALUES (?,?,?)";
    public static final String SALES_BILL_PIECE_UPDATE = "UPDATE ventes_factures SET id=?,prefixe=?,date=?,clients_id=?,commerciaux_id=?,contenu=?,net_a_payer=?,echeance=?,date_relance=?,montant_regle=?,mode_reglement=?,solde_le=?,entreprise_id=?,locking=?,total_brut_ht=?,commentaire=?,total_taxes=?,montant_tva1=?,montant_tva2=?,montant_tva3=?,montant_tva4=?,montant_tva5=?,total_sous_total=?,ventes=?,update_user_id=?,update_time=?,tva_port=? WHERE id=? AND update_time=?";
    public static final String SALES_BILL_PIECE_DELETE = "DELETE FROM ventes_factures WHERE id=? AND update_time=?";
    public static final String SALES_BILL_PIECE_SELECT = "SELECT id,prefixe,date,clients_id,commerciaux_id,contenu,net_a_payer,echeance,date_relance,montant_regle,mode_reglement,solde_le,entreprise_id,locking,total_brut_ht,commentaire,total_taxes,montant_tva1,montant_tva2,montant_tva3,montant_tva4,montant_tva5,total_sous_total,ventes,update_user_id,update_time,tva_port FROM ventes_factures WHERE id=?";
    public static final String SALES_BILL_PIECE_SELECT_ALL = "SELECT id,prefixe,date,clients_id,commerciaux_id,contenu,net_a_payer,echeance,date_relance,montant_regle,mode_reglement,solde_le,entreprise_id,locking,total_brut_ht,commentaire,total_taxes,montant_tva1,montant_tva2,montant_tva3,montant_tva4,montant_tva5,total_sous_total,ventes,update_user_id,update_time,tva_port FROM ventes_factures WHERE entreprise_id=?";
    public static final String BUYS_PIECE_INSERT = "INSERT INTO achats (id,update_time,prefixe) VALUES (?,?,?)";
    public static final String BUYS_PIECE_UPDATE = "UPDATE achats SET id=?,date=?,entreprise_id=?,locking=?,fournisseurs_id=?,commerciaux_id=?,no_fact=?,prefixe=?,contenu=?,net_a_payer=?,total_brut_ht=?,total_taxes=?,montant_tva1=?,montant_tva2=?,montant_tva3=?,montant_tva4=?,montant_tva5=?,montant_regle=?,mode_reglement=?,recu_le=?,solde_le=?,commentaire=?,update_user_id=?,update_time=?,tva_port=? WHERE id=? AND update_time=?";
    public static final String BUYS_PIECE_DELETE = "DELETE FROM achats WHERE id=? AND update_time=?";
    public static final String BUYS_PIECE_SELECT = "SELECT id,date,entreprise_id,locking,fournisseurs_id,commerciaux_id,no_fact,prefixe,contenu,net_a_payer,total_brut_ht,total_taxes,montant_tva1,montant_tva2,montant_tva3,montant_tva4,montant_tva5,montant_regle,mode_reglement,recu_le,solde_le,commentaire,update_user_id,update_time,tva_port FROM achats WHERE id=?";
    public static final String BUYS_PIECE_SELECT_ALL = "SELECT id,date,entreprise_id,locking,fournisseurs_id,commerciaux_id,no_fact,prefixe,contenu,net_a_payer,total_brut_ht,total_taxes,montant_tva1,montant_tva2,montant_tva3,montant_tva4,montant_tva5,montant_regle,mode_reglement,recu_le,solde_le,commentaire,update_user_id,update_time,tva_port FROM achats WHERE entreprise_id=?";
    public static final String CUSTOMER_INSERT = "INSERT INTO clients (id,update_time) VALUES (?,?)";
    public static final String CUSTOMER_UPDATE = "UPDATE clients SET id=?,id_gln=?,raison_sociale=?,adresse_fact=?,cp_fact=?,ville_fact=?,pays_fact=?,adresse_livr=?,cp_livr=?,ville_livr=?,pays_livr=?,mode_reglement=?,civilite=?,no_compte=?,commerciaux_id=?,contact=?,fonction_contact=?,telephone=?,portable=?,fax=?,email=?,site_web=?,familles_clients_id=?,remise=?,remise_excep=?,echeance_paiement=?,total_encaisse=?,cota_fidelite=?,commentaire=?,adresse2_fact=?,adresse2_livr=?,banque=?,update_user_id=?,update_time=?,photo1=?,photo2=? WHERE id=? AND update_time=?";
    public static final String CUSTOMER_DELETE = "DELETE FROM clients WHERE id=? AND update_time=?";
    public static final String CUSTOMER_SELECT = "SELECT id,id_gln,raison_sociale,adresse_fact,cp_fact,ville_fact,pays_fact,adresse_livr,cp_livr,ville_livr,pays_livr,mode_reglement,civilite,no_compte,commerciaux_id,contact,fonction_contact,telephone,portable,fax,email,site_web,familles_clients_id,remise,remise_excep,echeance_paiement,total_encaisse,cota_fidelite,commentaire,adresse2_fact,adresse2_livr,banque,update_user_id,update_time,photo1,photo2 FROM clients WHERE id=?";
    public static final String CUSTOMER_SELECT_ALL = "SELECT id,id_gln,raison_sociale,adresse_fact,cp_fact,ville_fact,pays_fact,adresse_livr,cp_livr,ville_livr,pays_livr,mode_reglement,civilite,no_compte,commerciaux_id,contact,fonction_contact,telephone,portable,fax,email,site_web,familles_clients_id,remise,remise_excep,echeance_paiement,total_encaisse,cota_fidelite,commentaire,adresse2_fact,adresse2_livr,banque,update_user_id,update_time,photo1,photo2 FROM clients WHERE familles_clients_id=?";
    public static final String CUSTOMER_CASCADE_DELETE1 = "DELETE FROM remise_par_client WHERE clients_id=?";
    public static final String CUSTOMER_CASCADE_DELETE2 = "DELETE FROM remise_famart_par_client WHERE clients_id=?";
    public static final String CUSTOMER_CASCADE_DELETE3 = "SELECT id,update_time FROM ventes WHERE clients_id=?";
    public static final String CUSTOMER_CASCADE_UPDATE = "UPDATE clients SET familles_clients_id=? WHERE familles_clients_id=?";
    public static final String SUPPLIER_INSERT = "INSERT INTO fournisseurs (id,update_time) VALUES (?,?)";
    public static final String SUPPLIER_UPDATE = "UPDATE fournisseurs SET id=?,raison_sociale=?,adresse_com=?,cp_com=?,ville_com=?,pays_com=?,adresse_enlev=?,cp_enlev=?,ville_enlev=?,pays_enlev=?,civilite=?,no_compte=?,contact=?,fonction_contact=?,telephone=?,portable=?,fax=?,email=?,site_web=?,familles_fournisseurs_id=?,commentaire=?,adresse2_com=?,adresse2_enlev=?,update_user_id=?,update_time=?,gln=?,photo1=?,photo2=? WHERE id=? AND update_time=?";
    public static final String SUPPLIER_DELETE = "DELETE FROM fournisseurs WHERE id=? AND update_time=?";
    public static final String SUPPLIER_SELECT = "SELECT id,raison_sociale,adresse_com,cp_com,ville_com,pays_com,adresse_enlev,cp_enlev,ville_enlev,pays_enlev,civilite,no_compte,contact,fonction_contact,telephone,portable,fax,email,site_web,familles_fournisseurs_id,commentaire,adresse2_com,adresse2_enlev,update_user_id,update_time,gln,photo1,photo2 FROM fournisseurs WHERE id=?";
    public static final String SUPPLIER_SELECT_ALL = "SELECT id,raison_sociale,adresse_com,cp_com,ville_com,pays_com,adresse_enlev,cp_enlev,ville_enlev,pays_enlev,civilite,no_compte,contact,fonction_contact,telephone,portable,fax,email,site_web,familles_fournisseurs_id,commentaire,adresse2_com,adresse2_enlev,update_user_id,update_time,gln,photo1,photo2 FROM fournisseurs";
    public static final String SUPPLIER_CASCADE_UPDATE = "UPDATE fournisseurs SET familles_fournisseurs_id=? WHERE familles_fournisseurs_id=?";
    public static final String ITEM_INSERT = "INSERT INTO articles (ref_code_barre,update_time) VALUES (?,?)";
    public static final String ITEM_UPDATE = "UPDATE articles SET designation=?,familles_articles_id=?,ref_code_barre=?,price_list2=?,price_list3=?,price_list4=?,tva_id=?,fournisseurs_id=?,promotion=?,emplacement=?,web=?,prix_revient=?,price_list1=?,commentaire=?,alerte=?,unite_vente=?,update_user_id=?,update_time=?,date2=?,date3=?,date4=?,date=?,detail_revient=?,free1=?,free2=?,prix_achat_pondere=?,packaging=?,gtin=?,photo1=?,photo2=?,photo3=?,photo4=?,photo5=?,photo6=?,photo7=?,photo8=?,photo9=?,photo10=?,photos_valid=?,description=? WHERE ref_code_barre=? AND update_time=?";
    public static final String ITEM_DELETE = "DELETE FROM articles WHERE ref_code_barre=? AND update_time=?";
    public static final String ITEM_SELECT = "SELECT designation,familles_articles_id,ref_code_barre,price_list2,price_list3,price_list4,tva_id,fournisseurs_id,promotion,emplacement,web,prix_revient,price_list1,commentaire,alerte,unite_vente,update_user_id,update_time,date2,date3,date4,date,detail_revient,free1,free2,prix_achat_pondere,packaging,gtin,photo1,photo2,photo3,photo4,photo5,photo6,photo7,photo8,photo9,photo10,photos_valid,description FROM articles WHERE ref_code_barre=?";
    public static final String ITEM_SELECT_ALL = "SELECT designation,familles_articles_id,ref_code_barre,price_list2,price_list3,price_list4,tva_id,fournisseurs_id,promotion,emplacement,web,prix_revient,price_list1,commentaire,alerte,unite_vente,update_user_id,update_time,date2,date3,date4,date,detail_revient,free1,free2,prix_achat_pondere,packaging,gtin,photo1,photo2,photo3,photo4,photo5,photo6,photo7,photo8,photo9,photo10,photos_valid,description FROM articles WHERE familles_articles_id=?";
    public static final String ITEM_CASCADE_UPDATE = "UPDATE articles SET familles_articles_id=? WHERE familles_articles_id=?";
    public static final String PAYMENT_INSERT = "INSERT INTO reglements_clients (id,update_time) VALUES (?,?)";
    public static final String PAYMENT_UPDATE = "UPDATE reglements_clients SET id=?,prefix=?,piece_id=?,montant=?,mode=?,date=?,pointage=?,numero=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String PAYMENT_DELETE = "DELETE FROM reglements_clients WHERE id=? AND update_time=?";
    public static final String PAYMENT_SELECT = "SELECT id,prefix,piece_id,montant,mode,date,pointage,numero,update_user_id,update_time FROM reglements_clients WHERE id=?";
    public static final String PAYMENT_SELECT_ALL = "SELECT id,prefix,piece_id,montant,mode,date,pointage,numero,update_user_id,update_time FROM reglements_clients WHERE piece_id=? AND prefix=?";
    public static final String REMINDER_INSERT = "INSERT INTO reminder (id,update_time) VALUES (?,?)";
    public static final String REMINDER_UPDATE = "UPDATE reminder SET id=?,piece_id=?,date=?,status=?,notes=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String REMINDER_DELETE = "DELETE FROM reminder WHERE id=? AND update_time=?";
    public static final String REMINDER_SELECT = "SELECT id,piece_id,date,status,notes,update_user_id,update_time FROM reminder WHERE id=?";
    public static final String REMINDER_SELECT_ALL = "SELECT id,piece_id,date,status,notes,update_user_id,update_time FROM reminder WHERE piece_id=?";
    public static final String SALES_PERSON_INSERT = "INSERT INTO commerciaux (id,update_time) VALUES (?,?)";
    public static final String SALES_PERSON_UPDATE = "UPDATE commerciaux SET id=?,nom=?,prenom=?,secteur=?,telephone=?,portable=?,fax=?,email=?,niveau=?,taux_vente=?,taux_total_vente=?,resultat=?,resultat_date=?,objectif=?,objectif_date=?,commentaire=?,update_user_id=?,update_time=?,sales_person_family_id=?,addr_ln1=?,addr_ln2=?,zip=?,city=?,country=? WHERE id=? AND update_time=?";
    public static final String SALES_PERSON_DELETE = "DELETE FROM commerciaux WHERE id=? AND update_time=?";
    public static final String SALES_PERSON_SELECT = "SELECT id,nom,prenom,secteur,telephone,portable,fax,email,niveau,taux_vente,taux_total_vente,resultat,resultat_date,objectif,objectif_date,commentaire,update_user_id,update_time,sales_person_family_id,addr_ln1,addr_ln2,zip,city,country FROM commerciaux WHERE id=?";
    public static final String SALES_PERSON_SELECT_ALL = "SELECT id,nom,prenom,secteur,telephone,portable,fax,email,niveau,taux_vente,taux_total_vente,resultat,resultat_date,objectif,objectif_date,commentaire,update_user_id,update_time,sales_person_family_id,addr_ln1,addr_ln2,zip,city,country FROM commerciaux ORDER BY nom";
    public static final String SALES_PERSON_CASCADE_UPDATE = "UPDATE commerciaux SET sales_person_family_id=? WHERE sales_person_family_id=?";
    public static final String AGENCY_INSERT = "INSERT INTO entreprise (id,update_time) VALUES (?,?)";
    public static final String AGENCY_UPDATE = "UPDATE entreprise SET id=?,raison_sociale=?,civilite=?,adresse=?,cp=?,ville=?,pays=?,telephone=?,fax=?,email=?,siret=?,naf=?,site_web=?,adresse2=?,telephone_deux=?,telephone_trois=?,fax_deux=?,fax_trois=?,update_user_id=?,update_time=?,gln=?,photo1=?,photo2=?,notes=? WHERE id=? AND update_time=?";
    public static final String AGENCY_DELETE = "DELETE FROM entreprise WHERE id=? AND update_time=?";
    public static final String AGENCY_SELECT = "SELECT id,raison_sociale,civilite,adresse,cp,ville,pays,telephone,fax,email,siret,naf,site_web,adresse2,telephone_deux,telephone_trois,fax_deux,fax_trois,update_user_id,update_time,gln,photo1,photo2,notes FROM entreprise WHERE id=?";
    public static final String AGENCY_SELECT_ALL = "SELECT id,raison_sociale,civilite,adresse,cp,ville,pays,telephone,fax,email,siret,naf,site_web,adresse2,telephone_deux,telephone_trois,fax_deux,fax_trois,update_user_id,update_time,gln,photo1,photo2,notes FROM entreprise ORDER BY id";
    public static final String SALES_ROWS_INSERT = "INSERT INTO contenu (id,update_time) VALUES (?,?)";
    public static final String SALES_ROWS_UPDATE = "UPDATE contenu SET id=?,line=?,status=?,facture_id=?,vente_id=?,article_id=?,designation=?,tva_id=?,lot_id=?,reliquat_id=?,quantite=?,prix_vente=?,prix_unitaire=?,total_ht=?,remise=?,update_user_id=?,update_time=?,batch_id=? WHERE id=? AND update_time=?";
    public static final String SALES_ROWS_DELETE = "DELETE FROM contenu WHERE id=? AND update_time=?";
    public static final String SALES_ROWS_CASCADE_DELETE = "DELETE FROM contenu WHERE vente_id=?";
    public static final String SALES_BILL_ROWS_CASCADE_DELETE = "DELETE FROM contenu WHERE facture_id=?";
    public static final String SALES_ROWS_SELECT = "SELECT id,line,status,facture_id,vente_id,article_id,designation,tva_id,lot_id,reliquat_id,quantite,prix_vente,prix_unitaire,total_ht,remise,update_user_id,update_time,batch_id FROM contenu WHERE id=?";
    public static final String SALES_ROWS_SELECT_ALL = "SELECT id,line,status,facture_id,vente_id,article_id,designation,tva_id,lot_id,reliquat_id,quantite,prix_vente,prix_unitaire,total_ht,remise,update_user_id,update_time,batch_id FROM contenu WHERE vente_id=? ORDER BY line";
    public static final String SALES_BILL_ROWS_SELECT_ALL = "SELECT id,line,status,facture_id,vente_id,article_id,designation,tva_id,lot_id,reliquat_id,quantite,prix_vente,prix_unitaire,total_ht,remise,update_user_id,update_time,batch_id FROM contenu WHERE facture_id=? ORDER BY line";
    public static final String BUYS_ROWS_INSERT = "INSERT INTO contenu_a (id,update_time) VALUES (?,?)";
    public static final String BUYS_ROWS_UPDATE = "UPDATE contenu_a SET id=?,line=?,status=?,facture_id=?,vente_id=?,article_id=?,designation=?,tva_id=?,lot_id=?,reliquat_id=?,quantite=?,prix_vente=?,prix_unitaire=?,total_ht=?,remise=?,update_user_id=?,update_time=?,batch_id=? WHERE id=? AND update_time=?";
    public static final String BUYS_ROWS_DELETE = "DELETE FROM contenu_a WHERE id=? AND update_time=?";
    public static final String BUYS_ROWS_CASCADE_DELETE = "DELETE FROM contenu_a WHERE vente_id=?";
    public static final String BUYS_ROWS_SELECT = "SELECT id,line,status,facture_id,vente_id,article_id,designation,tva_id,lot_id,reliquat_id,quantite,prix_vente,prix_unitaire,total_ht,remise,update_user_id,update_time,batch_id FROM contenu_a WHERE id=?";
    public static final String BUYS_ROWS_SELECT_ALL = "SELECT id,line,status,facture_id,vente_id,article_id,designation,tva_id,lot_id,reliquat_id,quantite,prix_vente,prix_unitaire,total_ht,remise,update_user_id,update_time,batch_id FROM contenu_a WHERE vente_id=? ORDER BY line";
    public static final String TAX_INSERT = "INSERT INTO tva (id,update_time) VALUES (?,?)";
    public static final String TAX_UPDATE = "UPDATE tva SET id=?,taux=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String TAX_DELETE = "DELETE FROM tva WHERE id=? AND update_time=?";
    public static final String TAX_SELECT = "SELECT id,taux,update_user_id,update_time FROM tva WHERE id=?";
    public static final String TAX_SELECT_ALL = "SELECT id,taux,update_user_id,update_time FROM tva ORDER BY id";
    public static final String BATCH_INSERT = "INSERT INTO batch (id,update_time) VALUES (?,?)";
    public static final String BATCH_UPDATE = "UPDATE batch SET id=?,buy_id=?,sscc=?,trucking_company=?,pallet_gtin=?,box_gtin=?,item_gtin=?,item_id=?,item_batch=?,delivery_form=?,supplier_gln=?,supplier_id=?,agency_id=?,input_stock_date=?,inventory_date=?,dlc=?,dluo=?,input_stock_quantity=?,stock_quantity=?,delta_inventory=?,packaging=?,unit=?,batch_price=?,status=?,notes=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String BATCH_DELETE = "DELETE FROM batch WHERE id=? AND update_time=?";
    public static final String BATCH_SELECT = "SELECT id,buy_id,sscc,trucking_company,pallet_gtin,box_gtin,item_gtin,item_id,item_batch,delivery_form,supplier_gln,supplier_id,agency_id,input_stock_date,inventory_date,dlc,dluo,input_stock_quantity,stock_quantity,delta_inventory,packaging,unit,batch_price,status,notes,update_user_id,update_time FROM batch WHERE id=?";
    public static final String BATCH_SELECT_ALL = "SELECT id,buy_id,sscc,trucking_company,pallet_gtin,box_gtin,item_gtin,item_id,item_batch,delivery_form,supplier_gln,supplier_id,agency_id,input_stock_date,inventory_date,dlc,dluo,input_stock_quantity,stock_quantity,delta_inventory,packaging,unit,batch_price,status,notes,update_user_id,update_time FROM batch WHERE agency_id=? AND item_batch=? ORDER BY id";
    public static final String LOG_STOCK_INSERT = "INSERT INTO journal_stock (id,update_time) VALUES (?,?)";
    public static final String LOG_STOCK_UPDATE = "UPDATE journal_stock SET id=?,operation=?,de=?,vers=?,quantite=?,date=?,update_user_id=?,update_time=?,articles_id=?,no_lot=?,commentaire=? WHERE id=? AND update_time=?";
    public static final String LOG_STOCK_DELETE = "DELETE FROM journal_stock WHERE id=? AND update_time=?";
    public static final String LOG_STOCK_SELECT = "SELECT id,operation,de,vers,quantite,date,update_user_id,update_time,articles_id,no_lot,commentaire FROM journal_stock WHERE id=?";
    public static final String LOG_STOCK_SELECT_ALL = "SELECT id,operation,de,vers,quantite,date,update_user_id,update_time,articles_id,no_lot,commentaire FROM journal_stock ORDER BY id";
    public static final String SENDING_INSERT = "INSERT INTO sending (id,update_time) VALUES (?,?)";
    public static final String SENDING_UPDATE = "UPDATE sending SET id=?,order_id=?,sscc=?,trucking_company=?,pallet_gtin=?,box_gtin=?,delivery_form=?,supplier_gln=?,supplier_id=?,agency_id=?,sending_date=?,preparation_date=?,delivery_anticipated_date=?,delivery_date=?,weight=?,parcel_quantity=?,packaging=?,unit=?,insurance_value=?,insurance_company=?,status=?,notes=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String SENDING_DELETE = "DELETE FROM sending WHERE id=? AND update_time=?";
    public static final String SENDING_SELECT = "SELECT id,order_id,sscc,trucking_company,pallet_gtin,box_gtin,delivery_form,supplier_gln,supplier_id,agency_id,sending_date,preparation_date,delivery_anticipated_date,delivery_date,weight,parcel_quantity,packaging,unit,insurance_value,insurance_company,status,notes,update_user_id,update_time FROM sending WHERE id=?";
    public static final String SENDING_SELECT_ALL = "SELECT id,order_id,sscc,trucking_company,pallet_gtin,box_gtin,delivery_form,supplier_gln,supplier_id,agency_id,sending_date,preparation_date,delivery_anticipated_date,delivery_date,weight,parcel_quantity,packaging,unit,insurance_value,insurance_company,status,notes,update_user_id,update_time FROM sending WHERE order_id=? ORDER BY id";
    public static final String BUY_NUMBER_INSERT = "INSERT INTO numero_achat (id) VALUES (?)";
    public static final String BUY_NUMBER_UPDATE = "UPDATE numero_achat SET id=?,time=? WHERE id=?";
    public static final String BUY_NUMBER_DELETE = "DELETE FROM numero_achat";
    public static final String BUY_NUMBER_SELECT = "SELECT id,time FROM numero_achat WHERE id=?";
    public static final String BUY_NUMBER_SELECT_ALL = "SELECT id,time FROM numero_achat ORDER BY id";
    public static final String SENDING_NUMBER_INSERT = "INSERT INTO numero_expedition (id) VALUES (?)";
    public static final String SENDING_NUMBER_UPDATE = "UPDATE numero_expedition SET id=?,time=? WHERE id=?";
    public static final String SENDING_NUMBER_DELETE = "DELETE FROM numero_expedition";
    public static final String SENDING_NUMBER_SELECT = "SELECT id,time FROM numero_expedition WHERE id=?";
    public static final String SENDING_NUMBER_SELECT_ALL = "SELECT id,time FROM numero_expedition ORDER BY id";
    public static final String SALES_BILL_NUMBER_INSERT = "INSERT INTO numero_facture (id) VALUES (?)";
    public static final String SALES_BILL_NUMBER_UPDATE = "UPDATE numero_facture SET id=?,time=? WHERE id=?";
    public static final String SALES_BILL_NUMBER_DELETE = "DELETE FROM numero_facture";
    public static final String SALES_BILL_NUMBER_SELECT = "SELECT id,time FROM numero_facture WHERE id=?";
    public static final String SALES_BILL_NUMBER_SELECT_ALL = "SELECT id,time FROM numero_facture ORDER BY id";
    public static final String BATCH_NUMBER_INSERT = "INSERT INTO numero_lot (id) VALUES (?)";
    public static final String BATCH_NUMBER_UPDATE = "UPDATE numero_lot SET id=?,time=? WHERE id=?";
    public static final String BATCH_NUMBER_DELETE = "DELETE FROM numero_lot";
    public static final String BATCH_NUMBER_SELECT = "SELECT id,time FROM numero_lot WHERE id=?";
    public static final String BATCH_NUMBER_SELECT_ALL = "SELECT id,time FROM numero_lot ORDER BY id";
    public static final String SALES_NUMBER_INSERT = "INSERT INTO numero_vente (id) VALUES (?)";
    public static final String SALES_NUMBER_UPDATE = "UPDATE numero_vente SET id=?,time=? WHERE id=?";
    public static final String SALES_NUMBER_DELETE = "DELETE FROM numero_vente";
    public static final String SALES_NUMBER_SELECT = "SELECT id,time FROM numero_vente WHERE id=?";
    public static final String SALES_NUMBER_SELECT_ALL = "SELECT id,time FROM numero_vente ORDER BY id";
    public static final String ITEM_FAMILY_INSERT = "INSERT INTO familles_articles (id,update_time) VALUES (?,?)";
    public static final String ITEM_FAMILY_UPDATE = "UPDATE familles_articles SET id=?,designation=?,coefficient=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String ITEM_FAMILY_DELETE = "DELETE FROM familles_articles WHERE id=? AND update_time=?";
    public static final String ITEM_FAMILY_SELECT = "SELECT id,designation,coefficient,update_user_id,update_time FROM familles_articles WHERE id=?";
    public static final String ITEM_FAMILY_SELECT_ALL = "SELECT id,designation,coefficient,update_user_id,update_time FROM familles_articles ORDER BY id";
    public static final String CUSTOMER_FAMILY_INSERT = "INSERT INTO familles_clients (id,update_time) VALUES (?,?)";
    public static final String CUSTOMER_FAMILY_UPDATE = "UPDATE familles_clients SET id=?,designation=?,coefficient=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String CUSTOMER_FAMILY_DELETE = "DELETE FROM familles_clients WHERE id=? AND update_time=?";
    public static final String CUSTOMER_FAMILY_SELECT = "SELECT id,designation,coefficient,update_user_id,update_time FROM familles_clients WHERE id=?";
    public static final String CUSTOMER_FAMILY_SELECT_ALL = "SELECT id,designation,coefficient,update_user_id,update_time FROM familles_clients ORDER BY id";
    public static final String SUPPLIER_FAMILY_INSERT = "INSERT INTO familles_fournisseurs (id,update_time) VALUES (?,?)";
    public static final String SUPPLIER_FAMILY_UPDATE = "UPDATE familles_fournisseurs SET id=?,designation=?,coefficient=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String SUPPLIER_FAMILY_DELETE = "DELETE FROM familles_fournisseurs WHERE id=? AND update_time=?";
    public static final String SUPPLIER_FAMILY_SELECT = "SELECT id,designation,coefficient,update_user_id,update_time FROM familles_fournisseurs WHERE id=?";
    public static final String SUPPLIER_FAMILY_SELECT_ALL = "SELECT id,designation,coefficient,update_user_id,update_time FROM familles_fournisseurs ORDER BY id";
    public static final String SALES_PERSON_FAMILY_INSERT = "INSERT INTO sales_person_family (id,update_time) VALUES (?,?)";
    public static final String SALES_PERSON_FAMILY_UPDATE = "UPDATE sales_person_family SET id=?,designation=?,coefficient=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String SALES_PERSON_FAMILY_DELETE = "DELETE FROM sales_person_family WHERE id=? AND update_time=?";
    public static final String SALES_PERSON_FAMILY_SELECT = "SELECT id,designation,coefficient,update_user_id,update_time FROM sales_person_family WHERE id=?";
    public static final String SALES_PERSON_FAMILY_SELECT_ALL = "SELECT id,designation,coefficient,update_user_id,update_time FROM sales_person_family ORDER BY id";
    public static final String DETAILS_LIST_INSERT = "INSERT INTO detail_list (id,update_time) VALUES (?,?)";
    public static final String DETAILS_LIST_UPDATE = "UPDATE detail_list SET id=?,name=?,category=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String DETAILS_LIST_DELETE = "DELETE FROM detail_list WHERE id=? AND update_time=?";
    public static final String DETAILS_LIST_SELECT = "SELECT id,name,category,update_user_id,update_time FROM detail_list WHERE id=?";
    public static final String DETAILS_LIST_SELECT_ALL = "SELECT id,name,category,update_user_id,update_time FROM detail_list WHERE category=? ORDER BY id";
    public static final String ITEM_DETAILS_INSERT = "INSERT INTO detail_articles (id,update_time) VALUES (?,?)";
    public static final String ITEM_DETAILS_UPDATE = "UPDATE detail_articles SET id=?,detail_list_id=?,value=?,notes=?,image=?,parent_id=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String ITEM_DETAILS_DELETE = "DELETE FROM detail_articles WHERE id=? AND update_time=?";
    public static final String ITEM_DETAILS_SELECT = "SELECT id,detail_list_id,value,notes,image,parent_id,update_user_id,update_time FROM detail_articles WHERE id=?";
    public static final String ITEM_DETAILS_SELECT_ALL = "SELECT id,detail_list_id,value,notes,image,parent_id,update_user_id,update_time FROM detail_articles ORDER BY id";
    public static final String CUSTOMER_DETAILS_INSERT = "INSERT INTO detail_clients (id,update_time) VALUES (?,?)";
    public static final String CUSTOMER_DETAILS_UPDATE = "UPDATE detail_clients SET id=?,detail_list_id=?,value=?,notes=?,image=?,parent_id=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String CUSTOMER_DETAILS_DELETE = "DELETE FROM detail_clients WHERE id=? AND update_time=?";
    public static final String CUSTOMER_DETAILS_SELECT = "SELECT id,detail_list_id,value,notes,image,parent_id,update_user_id,update_time FROM detail_clients WHERE id=?";
    public static final String CUSTOMER_DETAILS_SELECT_ALL = "SELECT id,detail_list_id,value,notes,image,parent_id,update_user_id,update_time FROM detail_clients ORDER BY id";
    public static final String SALES_PERSON_DETAILS_INSERT = "INSERT INTO detail_commerciaux (id,update_time) VALUES (?,?)";
    public static final String SALES_PERSON_DETAILS_UPDATE = "UPDATE detail_commerciaux SET id=?,detail_list_id=?,value=?,notes=?,image=?,parent_id=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String SALES_PERSON_DETAILS_DELETE = "DELETE FROM detail_commerciaux WHERE id=? AND update_time=?";
    public static final String SALES_PERSON_DETAILS_SELECT = "SELECT id,detail_list_id,value,notes,image,parent_id,update_user_id,update_time FROM detail_commerciaux WHERE id=?";
    public static final String SALES_PERSON_DETAILS_SELECT_ALL = "SELECT id,detail_list_id,value,notes,image,parent_id,update_user_id,update_time FROM detail_commerciaux ORDER BY id";
    public static final String AGENCY_DETAILS_INSERT = "INSERT INTO detail_entreprise (id,update_time) VALUES (?,?)";
    public static final String AGENCY_DETAILS_UPDATE = "UPDATE detail_entreprise SET id=?,detail_list_id=?,value=?,notes=?,image=?,parent_id=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String AGENCY_DETAILS_DELETE = "DELETE FROM detail_entreprise WHERE id=? AND update_time=?";
    public static final String AGENCY_DETAILS_SELECT = "SELECT id,detail_list_id,value,notes,image,parent_id,update_user_id,update_time FROM detail_entreprise WHERE id=?";
    public static final String AGENCY_DETAILS_SELECT_ALL = "SELECT id,detail_list_id,value,notes,image,parent_id,update_user_id,update_time FROM detail_entreprise ORDER BY id";
    public static final String SUPPLIER_DETAILS_INSERT = "INSERT INTO detail_fournisseurs (id,update_time) VALUES (?,?)";
    public static final String SUPPLIER_DETAILS_UPDATE = "UPDATE detail_fournisseurs SET id=?,detail_list_id=?,value=?,notes=?,image=?,parent_id=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String SUPPLIER_DETAILS_DELETE = "DELETE FROM detail_fournisseurs WHERE id=? AND update_time=?";
    public static final String SUPPLIER_DETAILS_SELECT = "SELECT id,detail_list_id,value,notes,image,parent_id,update_user_id,update_time FROM detail_fournisseurs WHERE id=?";
    public static final String SUPPLIER_DETAILS_SELECT_ALL = "SELECT id,detail_list_id,value,notes,image,parent_id,update_user_id,update_time FROM detail_fournisseurs ORDER BY id";
    public static final String USER_DETAILS_INSERT = "INSERT INTO detail_utilisateurs (id,update_time) VALUES (?,?)";
    public static final String USER_DETAILS_UPDATE = "UPDATE detail_utilisateurs SET id=?,detail_list_id=?,value=?,notes=?,image=?,parent_id=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String USER_DETAILS_DELETE = "DELETE FROM detail_utilisateurs WHERE id=? AND update_time=?";
    public static final String USER_DETAILS_SELECT = "SELECT id,detail_list_id,value,notes,image,parent_id,update_user_id,update_time FROM detail_utilisateurs WHERE id=?";
    public static final String USER_DETAILS_SELECT_ALL = "SELECT id,detail_list_id,value,notes,image,parent_id,update_user_id,update_time FROM detail_utilisateurs ORDER BY id";
    public static final String USER_INSERT = "INSERT INTO utilisateurs (id,update_time) VALUES (?,?)";
    public static final String USER_UPDATE = "UPDATE utilisateurs SET id=?,password=?,nom=?,prenom=?,droits=?,groups=?,adrln1=?,adrln2=?,ville=?,cp=?,tel1=?,tel2=?,fax=?,email=?,job=?,notes=?,msg=?,nb_connection=?,expiry_date=?,update_user_id=?,update_time=?,photo1=?,photo2=? WHERE id=? AND update_time=?";
    public static final String USER_DELETE = "DELETE FROM utilisateurs WHERE id=? AND update_time=?";
    public static final String USER_SELECT = "SELECT id,password,nom,prenom,droits,groups,adrln1,adrln2,ville,cp,tel1,tel2,fax,email,job,notes,msg,nb_connection,expiry_date,update_user_id,update_time,photo1,photo2 FROM utilisateurs WHERE id=?";
    public static final String USER_SELECT_ALL = "SELECT id,password,nom,prenom,droits,groups,adrln1,adrln2,ville,cp,tel1,tel2,fax,email,job,notes,msg,nb_connection,expiry_date,update_user_id,update_time,photo1,photo2 FROM utilisateurs ORDER BY id";
    public static final String ITEM_DISCOUNT_INSERT = "INSERT INTO remise_par_client (id,update_time) VALUES (?,?)";
    public static final String ITEM_DISCOUNT_UPDATE = "UPDATE remise_par_client SET id=?,clients_id=?,articles_id=?,remise=?,qt_un=?,qt_deux=?,qt_trois=?,remise_qt_un=?,remise_qt_deux=?,remise_qt_trois=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String ITEM_DISCOUNT_DELETE = "DELETE FROM remise_par_client WHERE id=? AND update_time=?";
    public static final String ITEM_DISCOUNT_SELECT = "SELECT id,clients_id,articles_id,remise,qt_un,qt_deux,qt_trois,remise_qt_un,remise_qt_deux,remise_qt_trois,update_user_id,update_time FROM remise_par_client WHERE id=?";
    public static final String ITEM_DISCOUNT_SELECT_ALL = "SELECT id,clients_id,articles_id,remise,qt_un,qt_deux,qt_trois,remise_qt_un,remise_qt_deux,remise_qt_trois,update_user_id,update_time FROM remise_par_client WHERE clients_id=? ORDER BY articles_id";
    public static final String ITEM_FAMILY_DISCOUNT_INSERT = "INSERT INTO remise_famart_par_client (id,update_time) VALUES (?,?)";
    public static final String ITEM_FAMILY_DISCOUNT_UPDATE = "UPDATE remise_famart_par_client SET id=?,clients_id=?,familles_articles_id=?,remise=?,qt_un=?,qt_deux=?,qt_trois=?,remise_qt_un=?,remise_qt_deux=?,remise_qt_trois=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String ITEM_FAMILY_DISCOUNT_DELETE = "DELETE FROM remise_famart_par_client WHERE id=? AND update_time=?";
    public static final String ITEM_FAMILY_DISCOUNT_SELECT = "SELECT id,clients_id,familles_articles_id,remise,qt_un,qt_deux,qt_trois,remise_qt_un,remise_qt_deux,remise_qt_trois,update_user_id,update_time FROM remise_famart_par_client WHERE id=?";
    public static final String ITEM_FAMILY_DISCOUNT_SELECT_ALL = "SELECT id,clients_id,familles_articles_id,remise,qt_un,qt_deux,qt_trois,remise_qt_un,remise_qt_deux,remise_qt_trois,update_user_id,update_time FROM remise_famart_par_client WHERE clients_id=? ORDER BY familles_articles_id";
    public static final String ITEM_COMMISSION_INSERT = "INSERT INTO comm_par_article (id,update_time) VALUES (?,?)";
    public static final String ITEM_COMMISSION_UPDATE = "UPDATE comm_par_article SET id=?,commerciaux_id=?,articles_id=?,debut=?,fin=?,t=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String ITEM_COMMISSION_DELETE = "DELETE FROM comm_par_article WHERE id=? AND update_time=?";
    public static final String ITEM_COMMISSION_SELECT = "SELECT id,commerciaux_id,articles_id,debut,fin,t,update_user_id,update_time FROM comm_par_article WHERE id=?";
    public static final String ITEM_COMMISSION_SELECT_ALL = "SELECT id,commerciaux_id,articles_id,debut,fin,t,update_user_id,update_time FROM comm_par_article WHERE commerciaux_id=? ORDER BY articles_id";
    public static final String ITEM_FAMILY_COMMISSION_INSERT = "INSERT INTO comm_par_famille (id,update_time) VALUES (?,?)";
    public static final String ITEM_FAMILY_COMMISSION_UPDATE = "UPDATE comm_par_famille SET id=?,commerciaux_id=?,famille_articles_id=?,debut=?,fin=?,t=?,update_user_id=?,update_time=? WHERE id=? AND update_time=?";
    public static final String ITEM_FAMILY_COMMISSION_DELETE = "DELETE FROM comm_par_famille WHERE id=? AND update_time=?";
    public static final String ITEM_FAMILY_COMMISSION_SELECT = "SELECT id,commerciaux_id,famille_articles_id,debut,fin,t,update_user_id,update_time FROM comm_par_famille WHERE id=?";
    public static final String ITEM_FAMILY_COMMISSION_SELECT_ALL = "SELECT id,commerciaux_id,famille_articles_id,debut,fin,t,update_user_id,update_time FROM comm_par_famille WHERE commerciaux_id=? ORDER BY famille_articles_id";
    public static final String DB_INSERT = "INSERT INTO db (id,update_time) VALUES (?,?)";
    public static final String DB_UPDATE = "UPDATE db SET id=?,name=?,dbname=?,login=?,password=?,url=?,admin_login=?,admin_password=?,admin_url=?,notes=?,update_user_id=?,update_time=?,date=? WHERE id=? AND update_time=?";
    public static final String DB_DELETE = "DELETE FROM db WHERE id=? AND update_time=?";
    public static final String DB_SELECT = "SELECT id,name,dbname,login,password,url,admin_login,admin_password,admin_url,notes,update_user_id,update_time,date FROM db WHERE id=?";
    public static final String DB_SELECT_ALL = "SELECT id,name,dbname,login,password,url,admin_login,admin_password,admin_url,notes,update_user_id,update_time,date FROM db";
}
